package com.ran.sys.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ran.sys.entity.User;
import com.ran.sys.entity.Userinfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


@Mapper
public interface ManagerMapper extends BaseMapper<Userinfo> {

     @Select("SELECT user.id,user.username,user.phone,user.email,face.face_list FROM user,face WHERE user.face=face.id AND user.username=#{username}")
     public Userinfo selectInfo(String username);

}
